package com.xinqi.modules.course.demonstrate.service.impl;

import com.baomidou.mybatisplus.core.incrementer.IdentifierGenerator;
import com.xinqi.modules.course.course.mapper.CourseMapper;
import com.xinqi.modules.course.demonstrate.mapper.DemoHomeworkMapper;
import com.xinqi.modules.course.demonstrate.service.DemoHomeworkService;
import lombok.RequiredArgsConstructor;
import org.springframework.scheduling.annotation.Async;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.time.LocalDateTime;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;

/**
 * 示范课程--作业
 */

@Service("demoHomeworkService")
@RequiredArgsConstructor
public class DemoHomeworkServiceImpl implements DemoHomeworkService {

    private final IdentifierGenerator identifierGenerator;
    private final CourseMapper courseMapper;

    private final DemoHomeworkMapper demoHomeworkMapper;

    /**
     * 生成作业SQL数据
     */

    @Override
    @Async("threadPoolTaskExecutor")
    public void initHomeworkSql(Long userId, Long classId, Map<String, String> idsMap, Map<String, String> chatperMap) {

        StringBuilder homeworkSb = new StringBuilder();
        LocalDateTime timingTime = LocalDateTime.now().plusMinutes(5);
        LocalDateTime timingEnd = timingTime.plusDays(2);
        String homeWorkSql = "INSERT INTO homework.co_course_homework(`id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_delete`, `delete_time`, `user_id`, `title`, `link_address`, `content`, `fileurls`, `videos`, `images`, `chapter_id`, `course_id`, `class_id`, `synchro`, `class_ids`, `task_type`, `group_ids`, `limit_status`, `check_duplicate`, `warning_value`, `repulse`, `repetition_rate`, `is_repeat`, `repeat_day`, `repeated_day`, `now_release`, `timing`, `release_time`, `end_time`, `status`, `score`)" +
            " VALUES (" + idsMap.get("1663103282536943618") + ", 1645325062446964737, '2023-05-29 16:41:36', 1645325062446964737, '2023-05-31 11:23:16', 0, NULL, 1645325062446964737, '综合性学习作业（小组作业）—人无信不立', NULL, '“信”，即诚信，是中华民族的传统美德之一，也是社会主义核心价值观之一。在古人眼中，“信”是立身之本、交友之道、经商之魂、为政之要；在现代社会，诚信是公民的第二张身份证。无论古今，诚信应该成为个人必有的精神品质。先哲们在思考“信”这一道德规范时，留下了很多精彩论述。\n各小组分别搜集有关“信”的名言警句、成语典故、名人逸事及其他经典论述，理解“信”的传统内涵。汇总并整理本组搜集的资料，将资料按类别划分“交友之信”“经商之信”“国家之信”等。最后每个小组采取一种类别，每个人以word文档形式6月30日20：00前提交一份资料。小组长在“评论”中说明每组查找的资料类别，为什么选取该类别？', NULL, NULL, '[{\"url\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685350712641914-微信图片_20230529165809.png\",\"name\":\"微信图片_20230529165809.png\",\"type\":2,\"filename\":\"微信图片_20230529165809.png\",\"fileurl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685350712641914-微信图片_20230529165809.png\",\"fileUrl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685350712641914-微信图片_20230529165809.png\",\"size\":929496,\"ossFileName\":\"1685350712641914-微信图片_20230529165809.png\",\"width\":688,\"height\":686,\"progress\":100},{\"url\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685350712640467-微信图片_20230529165751.png\",\"name\":\"微信图片_20230529165751.png\",\"type\":2,\"filename\":\"微信图片_20230529165751.png\",\"fileurl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685350712640467-微信图片_20230529165751.png\",\"fileUrl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685350712640467-微信图片_20230529165751.png\",\"size\":852745,\"ossFileName\":\"1685350712640467-微信图片_20230529165751.png\",\"width\":686,\"height\":680,\"progress\":100},{\"url\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685350712641261-微信图片_20230529165758.png\",\"name\":\"微信图片_20230529165758.png\",\"type\":2,\"filename\":\"微信图片_20230529165758.png\",\"fileurl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685350712641261-微信图片_20230529165758.png\",\"fileUrl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685350712641261-微信图片_20230529165758.png\",\"size\":1075823,\"ossFileName\":\"1685350712641261-微信图片_20230529165758.png\",\"width\":688,\"height\":680,\"progress\":100}]', 1661193644769972225, NULL, 1661184856792928257, 0, NULL, 2, '1661534859780591618,1661534859784785921,1663104364570906625', 1, 0, 0, 0, 0, 0, 1, 1, 0, 0, '2023-05-30 20:11:52', '2023-05-31 11:30:00', 1, 100.00)," +
            "(" + idsMap.get("1663161671128354817") + ", 1645325062446964737, '2023-05-29 20:33:37', 1645325062446964737, '2023-05-30 20:11:32', 0, NULL, 1645325062446964737, '打卡作业—每日阅读感想', NULL, '读经典作品，更有利于文化积累，让自己的思想与大师们联网接轨。鲁迅的作品在当代中国，就像莎士比亚的作品在英国，普希金的作品在俄罗斯，已成为民族语言和文化的象征。读鲁迅，会比读当下流行的那些“文化快餐”书籍有更多的收获。请每位同学选择一本鲁迅的书籍进行课后阅读，在一个月内完成，并每天提交一篇不少于300字的读书感想。', NULL, NULL, '[{\"url\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685363211938448-下载.jpeg\",\"name\":\"下载.jpeg\",\"type\":2,\"filename\":\"下载.jpeg\",\"fileurl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685363211938448-下载.jpeg\",\"fileUrl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-29/1685363211938448-下载.jpeg\",\"size\":15647,\"ossFileName\":\"1685363211938448-下载.jpeg\",\"width\":201,\"height\":259,\"progress\":100}]', 1661193644778360833, NULL, 1661184856792928257, 0, NULL, 1, NULL, 0, 0, 0, 0, 0, 1, 3, 1, 0, 0, '2023-05-30 20:11:32', '2023-06-05 22:00:00', 1, 100.00)," +
            "(" + idsMap.get("1663374180027785217") + ", 1645325062446964737, '2023-05-30 10:38:03', 1645325062446964737, '2023-05-30 10:38:03', 0, NULL, 1645325062446964737, '未发布作业—家乡的风俗', NULL, '“离家三里远，别是一乡风。”我们的祖国幅员辽阔，民族众多，每个地方都有自己的风俗习惯.你的家乡有哪些风俗习惯? 请你介绍一种风俗，或写一写你参加一次风俗活动的经历。\n如果是介绍一种风俗，写之前，先查阅资料或问问长辈，深人了解这种风俗，想一想这种风俗的主要特点是什么，可以分几个方面介绍，重点介绍什么。在介绍的时候，可以适当写写自已对这种风俗的实际体验。\n如果是写自己参加风俗活动的亲身经历，则可以把这种风俗的特点或来历自然地穿插在合适的地方，如，“听爸爸说，这个习俗大有来历呢......”或“我查资料得知，元宵象征着......”，然后重点描写活动现场的情况和自身的感受。', NULL, NULL, '[{\"url\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685414187310182-OIP-C (2).jpeg\",\"name\":\"OIP-C (2).jpeg\",\"type\":2,\"filename\":\"OIP-C (2).jpeg\",\"fileurl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685414187310182-OIP-C (2).jpeg\",\"fileUrl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685414187310182-OIP-C (2).jpeg\",\"size\":19500,\"ossFileName\":\"1685414187310182-OIP-C (2).jpeg\",\"width\":281,\"height\":186,\"progress\":100},{\"url\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685414187311930-OIP-C.jpeg\",\"name\":\"OIP-C.jpeg\",\"type\":2,\"filename\":\"OIP-C.jpeg\",\"fileurl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685414187311930-OIP-C.jpeg\",\"fileUrl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685414187311930-OIP-C.jpeg\",\"size\":15957,\"ossFileName\":\"1685414187311930-OIP-C.jpeg\",\"width\":253,\"height\":180,\"progress\":100},{\"url\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685414199744267-OIP-C (1).jpeg\",\"name\":\"OIP-C (1).jpeg\",\"type\":2,\"filename\":\"OIP-C (1).jpeg\",\"fileurl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685414199744267-OIP-C (1).jpeg\",\"fileUrl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685414199744267-OIP-C (1).jpeg\",\"size\":18577,\"ossFileName\":\"1685414199744267-OIP-C (1).jpeg\",\"width\":276,\"height\":184,\"progress\":100}]', 1661193644774166530, NULL, 1661184856792928257, 0, NULL, 1, NULL, 1, 0, 0, 0, 0, 0, 1, 1, 0, 0, NULL, '2023-06-10 00:00:00', 0, 100.00)," +
            "(" + idsMap.get("1663704572006031361") + ", 1645325062446964737, '2023-05-31 08:30:55', 1645972241733963777, '2023-05-31 11:46:03', 0, NULL, 1645325062446964737, '定时发布作业——写作练习', NULL, '在成长过程中，每个人都会有欢笑，有感动，当然也会有泪水，有悲伤.....这此都是人生必不可少的体验，一点一滴都是生命中宝贵的财富。在你成长的过程中，有什么经历让你深受触动，难以忘怀? 回忆一下，把它写下来。题目自拟不少于500字。 提示： 1，四忆成长经历中让你动情的一些事，先与同学交流，看看他们的反应,再从中选择一件事落笔。 2.交代清楚事情的几个要素，如时间、地点、人物等，写出事情的起因、经过、结果。 3.在结尾处表达一下自己的感受，比如你受到了怎样的触动，它在你的成长中窗下了怎样的印迹等，可起到点题的作用。', NULL, NULL, NULL, 1661193644778360833, NULL, 1661184856792928257, 0, NULL, 1, NULL, 0, 0, 0, 0, 0, 0, 1, 1, 0, 1, '" + timingTime + "', '" + timingEnd + "', 0, 100.00)," +
            "(" + idsMap.get("1663751131439620098") + ", 1645972241733963777, '2023-05-31 11:35:55', 1645972241733963777, '2023-05-31 11:42:00', 0, NULL, 1645972241733963777, '第一节  生物的特征作业（助教发布）', NULL, '什么是生物?也许你会说，能生长的东西就是生物。岩洞里的钟乳石也能从小长大，它也是生物吗?或许你还想到，能自主运动的东西就是生物树木花草不能移动位置，为什么说它们也是生物?请同学们以word的形式提交作业，描述你认为生物是什么？生物的特征是什么？', NULL, NULL, '[{\"url\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-31/1685504136333966-微信截图_20230531113518.png\",\"name\":\"微信截图_20230531113518.png\",\"type\":2,\"filename\":\"微信截图_20230531113518.png\",\"fileurl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-31/1685504136333966-微信截图_20230531113518.png\",\"fileUrl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-31/1685504136333966-微信截图_20230531113518.png\",\"size\":109415,\"ossFileName\":\"1685504136333966-微信截图_20230531113518.png\",\"width\":249,\"height\":166,\"progress\":100},{\"url\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-31/1685504136334138-微信截图_20230531113527.png\",\"name\":\"微信截图_20230531113527.png\",\"type\":2,\"filename\":\"微信截图_20230531113527.png\",\"fileurl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-31/1685504136334138-微信截图_20230531113527.png\",\"fileUrl\":\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-31/1685504136334138-微信截图_20230531113527.png\",\"size\":117338,\"ossFileName\":\"1685504136334138-微信截图_20230531113527.png\",\"width\":249,\"height\":165,\"progress\":100}]', NULL, NULL, 1661184856792928257, 0, NULL, 1, NULL, 1, 0, 0, 0, 0, 0, 1, 1, 0, 0, '2023-05-31 11:36:21', '2023-05-31 11:45:00', 1, 100.00);";
        homeWorkSql = homeWorkSql.replaceAll("1661184856792928257", classId.toString());
        // 更新章节
        Set<String> keyList = chatperMap.keySet();
        for (String item : keyList) {
            String value = chatperMap.get(item);
            homeWorkSql = homeWorkSql.replaceAll(item, value);
        }
        homeworkSb.append(homeWorkSql);

        // 生成学生日志记录
        String logSql = "INSERT INTO homework.co_course_homework_student_log(`id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_delete`, `delete_time`, `class_id`, `content_id`, `student_id`, `is_read`, `record_id`, `student_score`, `is_marked`, `hand_times`, `submit_status`, `calls`, `call_time`, `repulse_total`, `share`, `sharetitle`, `is_reviewed`, `anonymous`, `task_status`, `marked_num`, `times`, `is_partake`)" +
            "VALUES (" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:28:37', 0, 0, 1661184856792928257, 1663161671128354817, 1650458704827445249, 1, NULL, 90.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 4, 0, 1, 1)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1653986821394567169, '2023-05-30 20:24:38', 0, 0, 1661184856792928257, 1663161671128354817, 1653986821394567169, 1, NULL, 0.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 1, 0, 1, 1)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1654693737893134337, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1655410589569056769, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1655650372358701057, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:29:52', 0, 0, 1661184856792928257, 1663161671128354817, 1656548738307391489, 1, NULL, 92.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 4, 0, 1, 1)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1659403958154625026, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1661185385489694721, '2023-05-30 20:21:12', 0, 0, 1661184856792928257, 1663161671128354817, 1661185385489694721, 1, NULL, 0.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 1, 0, 1, 1)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1650458704827445249, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 2, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1653986821394567169, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 2, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1654693737893134337, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 2, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1655410589569056769, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 2, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1655650372358701057, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 2, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1656548738307391489, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 2, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1659403958154625026, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 2, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1661185385489694721, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 2, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1650458704827445249, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 3, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1653986821394567169, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 3, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1654693737893134337, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 3, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1655410589569056769, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 3, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1655650372358701057, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 3, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1656548738307391489, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 3, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1659403958154625026, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 3, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:32', 1645325062446964737, '2023-05-30 20:11:32', 0, 0, 1661184856792928257, 1663161671128354817, 1661185385489694721, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 3, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:52', 1650458704827445249, '2023-05-30 20:38:39', 0, 0, 1661184856792928257, 1663103282536943618, 1650458704827445249, 1, NULL, 90.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 4, 0, 1, 1)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:52', 1654693737893134337, '2023-05-30 20:25:17', 0, 0, 1661184856792928257, 1663103282536943618, 1654693737893134337, 1, NULL, 0.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 1, 0, 1, 1)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:52', 1661185385489694721, '2023-05-30 20:36:13', 0, 0, 1661184856792928257, 1663103282536943618, 1661185385489694721, 1, NULL, 88.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 4, 0, 1, 1)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:52', 1659403958154625026, '2023-06-14 21:50:26', 0, 0, 1661184856792928257, 1663103282536943618, 1659403958154625026, 1, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:52', 1653986821394567169, '2023-05-30 20:24:05', 0, 0, 1661184856792928257, 1663103282536943618, 1653986821394567169, 1, NULL, 0.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 1, 0, 1, 1)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:52', 1645325062446964737, '2023-05-30 20:11:52', 0, 0, 1661184856792928257, 1663103282536943618, 1655650372358701057, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:52', 1645325062446964737, '2023-05-30 20:11:52', 0, 0, 1661184856792928257, 1663103282536943618, 1655410589569056769, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-30 20:11:52', 1656548738307391489, '2023-05-30 20:30:29', 0, 0, 1661184856792928257, 1663103282536943618, 1656548738307391489, 1, NULL, 92.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 4, 0, 1, 1)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-31 08:30:55', 1645325062446964737, '2023-05-31 08:30:55', 0, 0, 1661184856792928257, 1663704572006031361, 1650458704827445249, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-31 08:30:55', 1645325062446964737, '2023-05-31 08:30:55', 0, 0, 1661184856792928257, 1663704572006031361, 1653986821394567169, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-31 08:30:55', 1645325062446964737, '2023-05-31 08:30:55', 0, 0, 1661184856792928257, 1663704572006031361, 1654693737893134337, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-31 08:30:55', 1645325062446964737, '2023-05-31 08:30:55', 0, 0, 1661184856792928257, 1663704572006031361, 1655410589569056769, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-31 08:30:55', 1645325062446964737, '2023-05-31 08:30:55', 0, 0, 1661184856792928257, 1663704572006031361, 1655650372358701057, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-31 08:30:55', 1645325062446964737, '2023-05-31 08:30:55', 0, 0, 1661184856792928257, 1663704572006031361, 1656548738307391489, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-31 08:30:55', 1645325062446964737, '2023-05-31 08:30:55', 0, 0, 1661184856792928257, 1663704572006031361, 1659403958154625026, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645325062446964737, '2023-05-31 08:30:55', 1645325062446964737, '2023-05-31 08:30:55', 0, 0, 1661184856792928257, 1663704572006031361, 1661185385489694721, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645972241733963777, '2023-05-31 11:36:21', 1645972241733963777, '2023-05-31 11:36:21', 0, 0, 1661184856792928257, 1663751131439620098, 1650458704827445249, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645972241733963777, '2023-05-31 11:36:21', 1645972241733963777, '2023-05-31 11:36:21', 0, 0, 1661184856792928257, 1663751131439620098, 1653986821394567169, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645972241733963777, '2023-05-31 11:36:21', 1645972241733963777, '2023-05-31 11:36:21', 0, 0, 1661184856792928257, 1663751131439620098, 1654693737893134337, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645972241733963777, '2023-05-31 11:36:21', 1645972241733963777, '2023-05-31 11:36:21', 0, 0, 1661184856792928257, 1663751131439620098, 1655410589569056769, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645972241733963777, '2023-05-31 11:36:21', 1645972241733963777, '2023-05-31 11:36:21', 0, 0, 1661184856792928257, 1663751131439620098, 1655650372358701057, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645972241733963777, '2023-05-31 11:36:21', 1645972241733963777, '2023-05-31 11:41:28', 0, 0, 1661184856792928257, 1663751131439620098, 1656548738307391489, 1, NULL, 90.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 4, 0, 1, 1)," +
            "(" + identifierGenerator.nextId(null) + ", 1645972241733963777, '2023-05-31 11:36:21', 1645972241733963777, '2023-05-31 11:36:21', 0, 0, 1661184856792928257, 1663751131439620098, 1659403958154625026, 0, NULL, 0.00, 0, 0, 0, 0, NULL, 0, 0, '', 0, 0, 0, 0, 1, 0)," +
            "(" + identifierGenerator.nextId(null) + ", 1645972241733963777, '2023-05-31 11:36:21', 1661185385489694721, '2023-05-31 11:40:37', 0, 0, 1661184856792928257, 1663751131439620098, 1661185385489694721, 1, NULL, 0.00, 0, 1, 1, 0, NULL, 0, 0, '', 0, 0, 1, 0, 1, 1);";
        // 更新作业ID
        Set<String> logList = idsMap.keySet();
        for (String item : logList) {
            String value = idsMap.get(item);
            logSql = logSql.replaceAll(item, value);
        }
        // 更新班级ID
        logSql = logSql.replaceAll("1661184856792928257", classId.toString());
        homeworkSb.append(logSql);

        // 记录表ID集合
        Map<String, String> recordMap = new HashMap<>();
        recordMap.put("1663521960293621761", identifierGenerator.nextId(null).toString());
        recordMap.put("1663519662142185473", identifierGenerator.nextId(null).toString());
        recordMap.put("1663520103747870721", identifierGenerator.nextId(null).toString());
        recordMap.put("1663520301404446722", identifierGenerator.nextId(null).toString());
        recordMap.put("1663521658123378689", identifierGenerator.nextId(null).toString());
        recordMap.put("1663519516666945538", identifierGenerator.nextId(null).toString());
        recordMap.put("1663519913699762177", identifierGenerator.nextId(null).toString());
        recordMap.put("1663520243799875585", identifierGenerator.nextId(null).toString());
        recordMap.put("1663521795813990401", identifierGenerator.nextId(null).toString());
        recordMap.put("1663751855074500610", identifierGenerator.nextId(null).toString());
        recordMap.put("1663752311905509377", identifierGenerator.nextId(null).toString());

        String recordSql = "INSERT INTO homework.co_course_homework_record(`id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_delete`, `delete_time`, `class_id`, `content_id`, `times`, `student_id`, `hand_title`, `hand_time`, `student_remark`, `teacher_remark`, `teacher_comment`, `is_repulse`, `repulse_reason`, `font_num`, `simhash`, `simhash_rate`, `in_progerss`)" +
            "VALUES (" + recordMap.get("1663521960293621761") + ", 1654693737893134337, '2023-05-30 20:25:17', 1654693737893134337, '2023-05-30 20:25:17', 0, 0, 1661184856792928257, 1663103282536943618, 1, 1654693737893134337, '', '2023-05-30 20:25:17', '', '', '', NULL, '', 0, NULL, 0, 1)," +
            "(" + recordMap.get("1663519662142185473") + ", 1650458704827445249, '2023-05-30 20:16:09', 1650458704827445249, '2023-05-30 20:16:09', 0, 0, 1661184856792928257, 1663103282536943618, 1, 1650458704827445249, '', '2023-05-30 20:16:09', '', '', '非常棒', NULL, '', 0, NULL, 0, 1)," +
            "(" + recordMap.get("1663520103747870721") + ", 1656548738307391489, '2023-05-30 20:17:54', 1656548738307391489, '2023-05-30 20:17:54', 0, 0, 1661184856792928257, 1663103282536943618, 1, 1656548738307391489, '', '2023-05-30 20:17:54', '我收集的是关于诚信的成语典故', '', '非常棒', NULL, '', 0, NULL, 0, 1)," +
            "(" + recordMap.get("1663520301404446722") + ", 1661185385489694721, '2023-05-30 20:18:41', 1661185385489694721, '2023-05-30 20:18:41', 0, 0, 1661184856792928257, 1663103282536943618, 1, 1661185385489694721, '', '2023-05-30 20:18:41', '', '', '很不错', NULL, '', 0, NULL, 0, 1)," +
            "(" + recordMap.get("1663521658123378689") + ", 1653986821394567169, '2023-05-30 20:24:05', 1653986821394567169, '2023-05-30 20:24:05', 0, 0, 1661184856792928257, 1663103282536943618, 1, 1653986821394567169, '', '2023-05-30 20:24:05', '', '', '', NULL, '', 0, NULL, 0, 1)," +
            "(" + recordMap.get("1663519516666945538") + ", 1650458704827445249, '2023-05-30 20:15:34', 1650458704827445249, '2023-05-30 20:15:34', 0, 0, 1661184856792928257, 1663161671128354817, 1, 1650458704827445249, '', '2023-05-30 20:15:34', '', '', '段落清楚，条理分明，文笔美丽', NULL, '', 0, NULL, 0, 1)," +
            "(" + recordMap.get("1663519913699762177") + ", 1656548738307391489, '2023-05-30 20:17:09', 1656548738307391489, '2023-05-30 20:17:09', 0, 0, 1661184856792928257, 1663161671128354817, 1, 1656548738307391489, '', '2023-05-30 20:17:09', '', '', '用词妥切，议论精当。', NULL, '', 0, NULL, 0, 1)," +
            "(" + recordMap.get("1663520243799875585") + ", 1661185385489694721, '2023-05-30 20:18:27', 1661185385489694721, '2023-05-30 20:18:27', 0, 0, 1661184856792928257, 1663161671128354817, 1, 1661185385489694721, '', '2023-05-30 20:18:27', '', '', '', NULL, '', 0, NULL, 0, 1)," +
            "(" + recordMap.get("1663521795813990401") + ", 1653986821394567169, '2023-05-30 20:24:38', 1653986821394567169, '2023-05-30 20:24:38', 0, 0, 1661184856792928257, 1663161671128354817, 1, 1653986821394567169, '', '2023-05-30 20:24:38', '', '', '', NULL, '', 0, NULL, 0, 1)," +
            "(" + recordMap.get("1663751855074500610") + ", 1656548738307391489, '2023-05-31 11:38:48', 1656548738307391489, '2023-05-31 11:38:48', 0, 0, 1661184856792928257, 1663751131439620098, 1, 1656548738307391489, '', '2023-05-31 11:38:48', '', '', '', NULL, '', 0, NULL, 0, 1)," +
            "(" + recordMap.get("1663752311905509377") + ", 1661185385489694721, '2023-05-31 11:40:37', 1661185385489694721, '2023-05-31 11:40:37', 0, 0, 1661184856792928257, 1663751131439620098, 1, 1661185385489694721, '', '2023-05-31 11:40:37', '', '', '', NULL, '', 0, NULL, 0, 1);";
        // 更新作业ID
        Set<String> recordList = idsMap.keySet();
        for (String item : recordList) {
            String value = idsMap.get(item);
            recordSql = recordSql.replaceAll(item, value);
        }
        // 更新班级ID
        recordSql = recordSql.replaceAll("1661184856792928257", classId.toString());
        homeworkSb.append(recordSql);

        // 作业提交记录表
        String fileSql = "INSERT INTO homework.co_course_homework_file(`id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_delete`, `delete_time`, `record_id`, `type`, `filename`, `fileurl`, `suffix`, `width`, `height`, `size`, `duration`, `fileTransformImg`, `teacherimg`)" +
            "VALUES (" + identifierGenerator.nextId(null) + ", 1650458704827445249, '2023-05-30 20:15:34', 1, '2023-05-30 20:15:36', 0, NULL, 1663519516666945538, 1, '《朝花夕拾》读后感.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685448920149645-《朝花夕拾》读后感.docx', 'docx', NULL, NULL, 11563, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/c19691a2c531493a86704a8fb6a975ea/1.jpg\", \"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/c19691a2c531493a86704a8fb6a975ea/2.jpg\"]', NULL)," +
            "(" + identifierGenerator.nextId(null) + ", 1650458704827445249, '2023-05-30 20:16:09', 1, '2023-05-30 20:16:10', 0, NULL, 1663519662142185473, 1, '关于经商诚信的故事.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685448947901740-关于经商诚信的故事.docx', 'docx', NULL, NULL, 11680, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/eb14f3418e0c47d891fbb52b8db92611/1.jpg\"]', NULL)," +
            "(" + identifierGenerator.nextId(null) + ", 1656548738307391489, '2023-05-30 20:17:09', 1, '2023-05-30 20:17:09', 0, NULL, 1663519913699762177, 1, '《故乡》读后感.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685449023490392-《故乡》读后感.docx', 'docx', NULL, NULL, 11529, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/9d93dedb9b3e4e79a4e9f1fedc13dd2c/1.jpg\"]', NULL)," +
            "(" + identifierGenerator.nextId(null) + ", 1656548738307391489, '2023-05-30 20:17:54', 1, '2023-05-30 20:17:55', 0, NULL, 1663520103747870721, 1, '关于诚信的成语典故.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685449047771791-关于诚信的成语典故.docx', 'docx', NULL, NULL, 11056, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/acb27099cd624f73acd311301707982e/1.jpg\"]', NULL)," +
            "(" + identifierGenerator.nextId(null) + ", 1661185385489694721, '2023-05-30 20:18:27', 1, '2023-05-30 20:18:28', 0, NULL, 1663520243799875585, 1, '《狂人日记》读后感.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685449101696332-《狂人日记》读后感.docx', 'docx', NULL, NULL, 11632, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/95a0b57b40004d749969b46b3f12cd0c/1.jpg\", \"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/95a0b57b40004d749969b46b3f12cd0c/2.jpg\"]', NULL)," +
            "(" + identifierGenerator.nextId(null) + ", 1661185385489694721, '2023-05-30 20:18:41', 1, '2023-05-30 20:18:42', 0, NULL, 1663520301404446722, 1, '关于诚信的名人故事.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/168544911659038-关于诚信的名人故事.docx', 'docx', NULL, NULL, 12381, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/18940ecf2b2a49c9b5373560382ba4db/1.jpg\", \"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/18940ecf2b2a49c9b5373560382ba4db/2.jpg\"]', NULL)," +
            "(" + identifierGenerator.nextId(null) + ", 1653986821394567169, '2023-05-30 20:24:05', 1, '2023-05-30 20:24:06', 0, NULL, 1663521658123378689, 1, '关于诚信的名言警句.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685449440435750-关于诚信的名言警句.docx', 'docx', NULL, NULL, 13776, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/8f37f33d1a274dc1980b2038d17ce06d/1.jpg\", \"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/8f37f33d1a274dc1980b2038d17ce06d/2.jpg\"]', NULL)," +
            "(" + identifierGenerator.nextId(null) + ", 1653986821394567169, '2023-05-30 20:24:38', 1, '2023-05-30 20:24:38', 0, NULL, 1663521795813990401, 1, '《药》读后感.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685449473096181-《药》读后感.docx', 'docx', NULL, NULL, 11763, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/c113ee2af23242eca43a52bc791332c0/1.jpg\", \"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/c113ee2af23242eca43a52bc791332c0/2.jpg\"]', NULL)," +
            "(" + identifierGenerator.nextId(null) + ", 1654693737893134337, '2023-05-30 20:25:17', 1, '2023-05-30 20:25:17', 0, NULL, 1663521960293621761, 1, '关于诚信的寓言.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-30/1685449512590717-关于诚信的寓言.docx', 'docx', NULL, NULL, 11207, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/30/slice/4b1174f68da949e29ef9be82e60d76fd/1.jpg\"]', NULL)," +
            "(" + identifierGenerator.nextId(null) + ", 1656548738307391489, '2023-05-31 11:38:48', 1, '2023-05-31 11:38:48', 0, NULL, 1663751855074500610, 1, '生物的特征.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-31/1685504322432150-生物的特征.docx', 'docx', NULL, NULL, 11819, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/31/slice/2d913f5da77949e49f7f715ca25161bf/1.jpg\"]', NULL)," +
            "(" + identifierGenerator.nextId(null) + ", 1661185385489694721, '2023-05-31 11:40:37', 1, '2023-05-31 11:40:37', 0, NULL, 1663752311905509377, 1, '生物的特征.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-31/1685504431939121-生物的特征.docx', 'docx', NULL, NULL, 11717, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/31/slice/984ef5152cc44b55878afcd41ca00d5d/1.jpg\"]', NULL);";
        // 更新记录表ID
        Set<String> fileList = recordMap.keySet();
        for (String item : fileList) {
            String value = recordMap.get(item);
            fileSql = fileSql.replaceAll(item, value);
        }
        homeworkSb.append(fileSql);

        // 执行SQL语句
        courseMapper.insertAllSql(homeworkSb.toString());
    }

    /**
     * 补充作业提交记录数据
     * @author dzy
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public Boolean supplyHomework() {
        List<Map<String, Long>> homeworkList = demoHomeworkMapper.findHomeworkNoRecord();
        homeworkList.forEach(map -> {
            StringBuilder homeworkSb = new StringBuilder();
            Long recordId1 = identifierGenerator.nextId(null).longValue();
            Long recordId2 = identifierGenerator.nextId(null).longValue();
            String recordSql = "INSERT INTO homework.co_course_homework_record(`id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_delete`, `delete_time`, `class_id`, `content_id`, `times`, `student_id`, `hand_title`, `hand_time`, `student_remark`, `teacher_remark`, `teacher_comment`, `is_repulse`, `repulse_reason`, `font_num`, `simhash`, `simhash_rate`, `in_progerss`)" +
                "VALUES (" + recordId1 + ", 1656548738307391489, '2023-05-31 11:38:48', 1656548738307391489, '2023-05-31 11:38:48', 0, 0, " + map.get("classId") + ", " + map.get("id") + ", 1, 1656548738307391489, '', '2023-05-31 11:38:48', '', '', '', NULL, '', 0, NULL, 0, 1)," +
                "(" + recordId2 + ", 1661185385489694721, '2023-05-31 11:40:37', 1661185385489694721, '2023-05-31 11:40:37', 0, 0, " + map.get("classId") + ", " + map.get("id") + ", 1, 1661185385489694721, '', '2023-05-31 11:40:37', '', '', '', NULL, '', 0, NULL, 0, 1);";
            homeworkSb.append(recordSql);
            // 作业提交记录表
            String fileSql = "INSERT INTO homework.co_course_homework_file(`id`, `create_by`, `create_time`, `update_by`, `update_time`, `is_delete`, `delete_time`, `record_id`, `type`, `filename`, `fileurl`, `suffix`, `width`, `height`, `size`, `duration`, `fileTransformImg`, `teacherimg`)" +
                "VALUES (" + identifierGenerator.nextId(null) + ", 1656548738307391489, '2023-05-31 11:38:48', 1, '2023-05-31 11:38:48', 0, NULL, " + recordId1 + ", 1, '生物的特征.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-31/1685504322432150-生物的特征.docx', 'docx', NULL, NULL, 11819, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/31/slice/2d913f5da77949e49f7f715ca25161bf/1.jpg\"]', NULL)," +
                "(" + identifierGenerator.nextId(null) + ", 1661185385489694721, '2023-05-31 11:40:37', 1, '2023-05-31 11:40:37', 0, NULL, " + recordId2 + ", 1, '生物的特征.docx', 'https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023-05-31/1685504431939121-生物的特征.docx', 'docx', NULL, NULL, 11717, NULL, '[\"https://xinqiclass.oss-cn-hangzhou.aliyuncs.com/2023/05/31/slice/984ef5152cc44b55878afcd41ca00d5d/1.jpg\"]', NULL);";
            homeworkSb.append(fileSql);
            courseMapper.insertAllSql(homeworkSb.toString());
        });
        return true;
    }

}
